CREATE TABLE [booking].[Itinerary]
(
[ItineraryId] [int] NOT NULL IDENTITY(1, 1),
[AgentId] [int] NOT NULL,
[PlannerId] [int] NULL,
[ItineraryRefNo] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ItineraryDate] [datetime] NOT NULL,
[CurrencyCode] [char] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CurrencySymbol] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ItineraryName] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CreatedBy] [int] NOT NULL,
[CreatedDate] [datetime] NOT NULL,
[UpdatedBy] [int] NULL,
[UpdatedDate] [datetime] NULL
) ON [PRIMARY]
GO
ALTER TABLE [booking].[Itinerary] ADD CONSTRAINT [PK_Itinerary] PRIMARY KEY CLUSTERED  ([ItineraryId]) ON [PRIMARY]
GO
